Problem Note 38079: Tables with more than 1 million rows might not display the correct number of rows in the preview window
In the SAS® Add-In for Microsoft Office, when you open and filter a table with more than 1 million rows in Excel, you might not see the correct number of rows when you preview the table. Instead, you might see something similar to the following:
Determining the number of observations in a table of more than 1 million rows would take a long time. Because of this, to improve performance, SAS places a null value in the space for the row count.
Operating System and Release Information
| SAS System | SAS Add-in for Microsoft Office | Windows Millennium Edition (Me) | 2.1 | | | |
| Microsoft Windows XP Professional | 2.1 | 4.22 | | 9.2 TS2M0 |
| Microsoft Windows Server 2008 | 2.1 | | | |
| Microsoft Windows Server 2003 Standard Edition | 2.1 | 4.22 | | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Enterprise Edition | 2.1 | 4.22 | | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 2.1 | 4.22 | | 9.2 TS2M0 |
| Microsoft Windows NT Workstation | 2.1 | | | |
| Microsoft Windows 2000 Professional | 2.1 | | | |
| Microsoft Windows 2000 Server | 2.1 | | | |
| Microsoft Windows 2000 Datacenter Server | 2.1 | | | |
| Microsoft Windows 2000 Advanced Server | 2.1 | | | |
| Microsoft Windows 95/98 | 2.1 | | | |
| Microsoft Windows 7 | 2.1 | | | |
| Windows Vista | 2.1 | 4.22 | | 9.2 TS2M0 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2009-12-14 10:55:53 |
| Date Created: | 2009-12-08 16:34:10 |
